{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Primary Spectacle Match"],"read":"whole","date_system":"1900"}

{"sheet":"Primary Spectacle Match","index":0,"n_rows":13,"n_cols":39,"rows_kept":13}
["Spectacle Match"]
[{"$nulls":14},"M-t","h","k",{"$nulls":4},"M-c","x","y",{"$nulls":4},"a","A","B","C"]
[]
[null,null,"Target Refraction",{"$nulls":3},"Candidate Refraction",null,null,"Interpupillary distance",{"$nulls":19},"quadratic",{"$nulls":3},"Cylinder",null,"Spherical Equivalent",null,"Pupillary Distance"]
["Patient","Age","Sphere-target","Cyl-target","Axis-target","PD-target","Sphere-cand","Cyl-cand","Axis-cand","PD-cand"," Sphere-t-adj","Cyl-t-adj","axis-t-adj",null,"M-target","J0-target","J45-target","Sphere-c-adj","Cyl-c-adj","AXIS-c-adj",null,"M-candidate","J0-candidate","J45-candidate",null,"excess accom","age accom","age-adj","major radius","A","B","C",null,"#-cyl","Grade cyl","#-Sph","Grade Sph","#-PD","Grade PD"]
["example 1",5,{"v":-2.5,"d":"-2.50"},{"v":1.5,"d":"1.50"},95,60,-3,2.25,102,65,{"$f":"C6","v":{"v":-2.5,"d":"-2.50"}},{"$f":"D6","v":{"v":1.5,"d":"1.50"}},45,null,{"$f":"K6+(L6/2)","v":-1.75},{"$f":"-((L6+0.000001)/2)*(COS(2*M6*3.1416/180))","v":{"v":2.7549056639459295E-6,"d":"0.00"}},{"$f":"-((0.000001+L6)/2)*(SIN(2*M6*3.1416/180))","v":{"v":-0.7500004999949402,"d":"-0.75"}},{"$f":"G6","v":-3},{"$f":"H6","v":2.25},{"$f":"I6+(45-E6)","v":52},null,{"$f":"R6+(S6/2)","v":-1.875},{"$f":"-((S6+0.000001)/2)*(COS(2*T6*3.1416/180))","v":{"v":0.2721668868339592,"d":"0.27"}},{"$f":"-((0.000001+S6)/2)*(SIN(2*T6*3.1416/180))","v":{"v":-1.0915820219806485,"d":"-1.09"}},null,{"$f":"-1*(O6-V6)","v":{"v":-0.125,"d":"-0.13"}},{"$f":"5.25*2.7183^(-0.05*B6)","v":{"v":4.088697277971759,"d":"4.09"}},{"$f":"IF(B6>70,70,B6)","v":5},{"$f":"SQRT((0.39*(W6-P6)^2+(X6-Q6)^2)/0.39)","v":{"v":0.6109398579202775,"d":"0.61"}},{"$f":"-0.034*L6-0.052","v":{"v":-0.10300000000000001,"d":"-0.10"}},{"$f":"0.26*L6+0.45","v":{"v":0.8400000000000001,"d":"0.84"}},{"$f":"-2*AC6","v":{"v":-1.221879715840555,"d":"-1.22"}},null,{"$f":"(-AE6+SQRT(AE6^2-4*AD6*AF6))/(2*AD6)","v":{"v":1.8949005668191878,"d":"1.89"}},{"$f":"IF(AH6<1.01,\"A\",IF(AH6<2.01,\"B\",IF(AH6<3.01,\"C\",\"poor match\")))","v":"B"},{"$f":"IF(Z6>0,2*Z6,(-1*Z6/(1.7-0.017*AB6)))","v":{"v":0.07739938080495357,"d":"0.08"}},{"$f":"IF(AJ6<1.01,\"A\",IF(AJ6<2.01,\"B\",IF(AJ6<3.01,\"C\",\"poor match\")))","v":"A"},{"$f":"(ABS(F6-J6))/(4.165*2.7183^(-0.1*O6))","v":{"v":1.0077503466058046,"d":"1.0"}},{"$f":"IF(AL6<1.01,\"A\",IF(AL6<2.01,\"B\",IF(AL6<3.01,\"C\",\"poor match\")))","v":"A"}]
["example 2",72,-2.5,1.5,95,60,-1.5,1,102,64,{"$f":"C7","v":{"v":-2.5,"d":"-2.50"}},{"$f":"D7","v":{"v":1.5,"d":"1.50"}},45,null,{"$f":"K7+(L7/2)","v":-1.75},{"$f":"-((L7+0.000001)/2)*(COS(2*M7*3.1416/180))","v":{"v":2.7549056639459295E-6,"d":"0.00"}},{"$f":"-((0.000001+L7)/2)*(SIN(2*M7*3.1416/180))","v":{"v":-0.7500004999949402,"d":"-0.75"}},{"$f":"G7","v":-1.5},{"$f":"H7","v":1},{"$f":"I7+(45-E7)","v":52},null,{"$f":"R7+(S7/2)","v":-1},{"$f":"-((S7+0.000001)/2)*(COS(2*T7*3.1416/180))","v":{"v":0.12096312801676352,"d":"0.12"}},{"$f":"-((0.000001+S7)/2)*(SIN(2*T7*3.1416/180))","v":{"v":-0.485147834851038,"d":"-0.49"}},null,{"$f":"-1*(O7-V7)","v":0.75},{"$f":"5.25*2.7183^(-0.05*B7)","v":{"v":0.14344609067754568,"d":"0.14"}},{"$f":"IF(B7>70,70,B7)","v":70},{"$f":"SQRT((0.39*(W7-P7)^2+(X7-Q7)^2)/0.39)","v":{"v":0.4410162647749726,"d":"0.44"}},{"$f":"-0.034*L7-0.052","v":{"v":-0.10300000000000001,"d":"-0.10"}},{"$f":"0.26*L7+0.45","v":{"v":0.8400000000000001,"d":"0.84"}},{"$f":"-2*AC7","v":{"v":-0.8820325295499452,"d":"-0.88"}},null,{"$f":"(-AE7+SQRT(AE7^2-4*AD7*AF7))/(2*AD7)","v":{"v":1.2379570265588045,"d":"1.24"}},{"$f":"IF(AH7<1.01,\"A\",IF(AH7<2.01,\"B\",IF(AH7<3.01,\"C\",\"poor match\")))","v":"B"},{"$f":"IF(Z7>0,2*Z7,(-1*Z7/(1.7-0.017*AB7)))","v":{"v":1.5,"d":"1.50"}},{"$f":"IF(AJ7<1.01,\"A\",IF(AJ7<2.01,\"B\",IF(AJ7<3.01,\"C\",\"poor match\")))","v":"B"},{"$f":"(ABS(F7-J7))/(4.165*2.7183^(-0.1*O7))","v":{"v":0.8062002772846437,"d":"0.8"}},{"$f":"IF(AL7<1.01,\"A\",IF(AL7<2.01,\"B\",IF(AL7<3.01,\"C\",\"poor match\")))","v":"A"}]
["example 3",75,-2,1,95,60,-3,1.5,98,64,{"v":-2,"d":"-2.00"},{"v":1,"d":"1.00"},45,null,-1.5,{"v":1.8366043881648033E-6,"d":"0.00"},{"v":-0.5000004999966268,"d":"-0.50"},-3,1.5,48,null,-2.25,{"v":0.07839932218263941,"d":"0.08"},{"v":-0.7458916116176348,"d":"-0.75"},null,-0.75,{"v":0.12346507063008698,"d":"0.12"},70,{"v":0.40146987438393333,"d":"0.40"},{"v":-0.086,"d":"-0.09"},0.71,{"v":-0.8029397487678667,"d":"-0.80"},null,{"$f":"(-AE8+SQRT(AE8^2-4*AD8*AF8))/(2*AD8)","v":{"v":1.3524597511514842,"d":"1.35"}},{"$f":"IF(AH8<1.01,\"A\",IF(AH8<2.01,\"B\",IF(AH8<3.01,\"C\",\"poor match\")))","v":"B"},{"v":1.4705882352941182,"d":"1.47"},"B",{"v":0.8266094726162515,"d":"0.8"},"A"]
["example 4",45,-1,2.5,95,60,-2.5,2.25,102,70,{"v":-1,"d":"-1.00"},{"v":2.5,"d":"2.50"},45,null,0.25,{"v":4.5915082155081815E-6,"d":"0.00"},{"v":-1.2500004999915673,"d":"-1.25"},-2.5,{"$f":"H9","v":2.25},52,null,-1.375,{"v":0.2721668868339592,"d":"0.27"},{"v":-1.0915820219806485,"d":"-1.09"},null,{"v":-1.625,"d":"-1.63"},{"v":0.553337606105014,"d":"0.55"},45,{"v":0.3720511993444365,"d":"0.37"},{"v":-0.137,"d":"-0.14"},{"v":1.1,"d":"1.10"},{"v":-0.744102398688873,"d":"-0.74"},null,{"v":0.7457153870567682,"d":"0.75"},"A",{"v":1.7379679144385027,"d":"1.74"},"B",{"v":2.4617413970660933,"d":"2.5"},"C"]
[{"$nulls":25},{"v":0,"d":"0.00"}]
["entry here-->",{"$nulls":9},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},45,null,0,{"v":1.8366025515622517E-12,"d":"0.00"},{"v":-4.9999999999662688E-7,"d":"-0.00"},0,0,45,null,0,{"v":1.8366025515622517E-12,"d":"0.00"},{"v":-4.9999999999662688E-7,"d":"-0.00"},null,{"v":0,"d":"0.00"},5.25,0,{"v":0,"d":"0.00"},{"v":-0.052,"d":"-0.05"},0.45,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},"A",{"v":0,"d":"0.00"},"A",{"v":0,"d":"0.0"},"A"]
["fill in -->",{"$nulls":9},{"$f":"C12","v":{"v":0,"d":"0.00"}},{"$f":"D12","v":{"v":0,"d":"0.00"}},45,null,{"$f":"K12+(L12/2)","v":0},{"$f":"-((L12+0.000001)/2)*(COS(2*M12*3.1416/180))","v":{"v":1.8366025515622517E-12,"d":"0.00"}},{"$f":"-((0.000001+L12)/2)*(SIN(2*M12*3.1416/180))","v":{"v":-4.9999999999662688E-7,"d":"-0.00"}},{"$f":"G12","v":0},{"$f":"H12","v":0},{"$f":"I12+(45-E12)","v":45},null,{"$f":"R12+(S12/2)","v":0},{"$f":"-((S12+0.000001)/2)*(COS(2*T12*3.1416/180))","v":{"v":1.8366025515622517E-12,"d":"0.00"}},{"$f":"-((0.000001+S12)/2)*(SIN(2*T12*3.1416/180))","v":{"v":-4.9999999999662688E-7,"d":"-0.00"}},null,{"v":0,"d":"0.00"},{"$f":"5.25*2.7183^(-0.05*B12)","v":5.25},0,{"$f":"SQRT((0.39*(W12-P12)^2+(X12-Q12)^2)/0.39)","v":{"v":0,"d":"0.00"}},{"$f":"-0.034*L12-0.052","v":{"v":-0.052,"d":"-0.05"}},{"$f":"0.26*L12+0.45","v":0.45},{"$f":"-2*AC12","v":{"v":0,"d":"0.00"}},null,{"$f":"(-AE12+SQRT(AE12^2-4*AD12*AF12))/(2*AD12)","v":{"v":0,"d":"0.00"}},{"$f":"IF(AH12<1.01,\"A\",IF(AH12<2.01,\"B\",IF(AH12<3.01,\"C\",\"poor match\")))","v":"A"},{"v":0,"d":"0.00"},{"$f":"IF(AJ12<1.01,\"A\",IF(AJ12<2.01,\"B\",IF(AJ12<3.01,\"C\",\"poor match\")))","v":"A"},{"$f":"(ABS(F12-J12))/(4.165*2.7183^(-0.1*O12))","v":{"v":0,"d":"0.0"}},{"$f":"IF(AL12<1.01,\"A\",IF(AL12<2.01,\"B\",IF(AL12<3.01,\"C\",\"poor match\")))","v":"A"}]
[{"$nulls":10},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},45,null,0,{"v":1.8366025515622517E-12,"d":"0.00"},{"v":-4.9999999999662688E-7,"d":"-0.00"},0,0,45,null,0,{"v":1.8366025515622517E-12,"d":"0.00"},{"v":-4.9999999999662688E-7,"d":"-0.00"},null,{"v":0,"d":"0.00"},5.25,0,{"v":0,"d":"0.00"},{"v":-0.052,"d":"-0.05"},0.45,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},"A",{"v":0,"d":"0.00"},"A",{"v":0,"d":"0.0"},"A"]